﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Model.Contact
{
    public partial class ContactInfo
    {
        public const string INSERT_SQL = "insert into [Contact] ( ID, Name, DirID, Headship, Mobile, Email, QQ, MSN, HomeAddr, HomePhone, HomeZip, CorpName, CorpSite, WorkPhone, WorkFax, WorkAddr, WorkZip, Orders, Remark, InputTime, CreatorID, CreatorName, IsPublic) values ( @ID, @Name, @DirID, @Headship, @Mobile, @Email, @QQ, @MSN, @HomeAddr, @HomePhone, @HomeZip, @CorpName, @CorpSite, @WorkPhone, @WorkFax, @WorkAddr, @WorkZip, @Orders, @Remark, @InputTime, @CreatorID, @CreatorName, @IsPublic)";
        public const string UPDATE_SQL = "update [Contact] set  ID = @ID, Name = @Name, DirID = @DirID, Headship = @Headship, Mobile = @Mobile, Email = @Email, QQ = @QQ, MSN = @MSN, HomeAddr = @HomeAddr, HomePhone = @HomePhone, HomeZip = @HomeZip, CorpName = @CorpName, CorpSite = @CorpSite, WorkPhone = @WorkPhone, WorkFax = @WorkFax, WorkAddr = @WorkAddr, WorkZip = @WorkZip, Orders = @Orders, Remark = @Remark, InputTime = @InputTime, CreatorID = @CreatorID, CreatorName = @CreatorName, IsPublic = @IsPublic where ID = @ID";
        public ContactInfo() { }
        public int ID
        {
            get;
            set;
        }
        public string Name
        {
            get;
            set;
        }
        public int DirID
        {
            get;
            set;
        }
        public string Headship
        {
            get;
            set;
        }
        public string Mobile
        {
            get;
            set;
        }
        public string Email
        {
            get;
            set;
        }
        public string QQ
        {
            get;
            set;
        }
        public string MSN
        {
            get;
            set;
        }
        public string HomeAddr
        {
            get;
            set;
        }
        public string HomePhone
        {
            get;
            set;
        }
        public string HomeZip
        {
            get;
            set;
        }
        public string CorpName
        {
            get;
            set;
        }
        public string CorpSite
        {
            get;
            set;
        }
        public string WorkPhone
        {
            get;
            set;
        }
        public string WorkFax
        {
            get;
            set;
        }
        public string WorkAddr
        {
            get;
            set;
        }
        public string WorkZip
        {
            get;
            set;
        }
        public int Orders
        {
            get;
            set;
        }
        public string Remark
        {
            get;
            set;
        }
        public DateTime InputTime
        {
            get;
            set;
        }
        public int CreatorID
        {
            get;
            set;
        }
        public string CreatorName
        {
            get;
            set;
        }
        public bool IsPublic
        {
            get;
            set;
        }
    }


}
